<?php require_once('connections/con_gl.php'); ?>
<?php
cekAkses($_SESSION[akses],"PD-1-3");
mysql_select_db($database_con_gl, $con_gl);
$query_kontak = "SELECT id, nama, type FROM gl_kontak ORDER BY type, nama ASC";
$kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error());
$row_kontak = mysql_fetch_assoc($kontak);
$totalRows_kontak = mysql_num_rows($kontak);

// ---
mysql_select_db($database_con_gl, $con_gl);
$query_gudang = "SELECT id, gudang FROM gl_gudang";
if(!strstr($_SESSION[akses],'A-1-4')) {
	$query_gudang .= " where id='$_SESSION[lokasi]'";
}
$query_gudang .=" ORDER BY gudang ASC";
$gudang = mysql_query($query_gudang, $con_gl) or die(mysql_error());
$row_gudang = mysql_fetch_assoc($gudang);
$totalRows_gudang = mysql_num_rows($gudang);

mysql_select_db($database_con_gl, $con_gl);
$query_satuan = "SELECT id, satuan FROM gl_satuan ORDER BY satuan ASC";
$satuan = mysql_query($query_satuan, $con_gl) or die(mysql_error());
$row_satuan = mysql_fetch_assoc($satuan);
$totalRows_satuan = mysql_num_rows($satuan);

mysql_select_db($database_con_gl, $con_gl);
$query_kelom = "SELECT id, kelompok FROM gl_kelompok where jenis='1'";
if(!strstr($_SESSION[akses],'A-1-4')) {
	$query_kelom .= " AND gudang='$_SESSION[lokasi]'";
}
$query_kelom .= " ORDER BY kelompok ASC";
$kelom = mysql_query($query_kelom, $con_gl) or die(mysql_error());
$row_kelom = mysql_fetch_assoc($kelom);
$totalRows_kelom = mysql_num_rows($kelom);

mysql_select_db($database_con_gl, $con_gl);
$query_klas = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas where tipe = 6 ORDER BY kd,klasifikasi ASC";
$klas = mysql_query($query_klas, $con_gl) or die(mysql_error());
$row_klas = mysql_fetch_assoc($klas);
$totalRows_klas = mysql_num_rows($klas);

mysql_select_db($database_con_gl, $con_gl);
$query_def_ak = "SELECT gl_company.a_kas FROM gl_company";
$def_ak = mysql_query($query_def_ak, $con_gl) or die(mysql_error());
$row_def_ak = mysql_fetch_assoc($def_ak);
$totalRows_def_ak = mysql_num_rows($def_ak);

$colname_edit = "-1";
if (isset($_GET['noreferensi'])) {
  $colname_edit = (get_magic_quotes_gpc()) ? $_GET['noreferensi'] : addslashes($_GET['noreferensi']);
}
mysql_select_db($database_con_gl, $con_gl);
$query_edit = sprintf("SELECT * FROM gl_rtrans WHERE no_ref = '$_GET[noreferensi]'", $colname_edit);
$edit = mysql_query($query_edit, $con_gl) or die(mysql_error());
$row_edit = mysql_fetch_assoc($edit);
$totalRows_edit = mysql_num_rows($edit);

mysql_select_db($database_con_gl, $con_gl);
$query_tr = "SELECT gl_trans.id, gl_trans.total, gl_trans.jumlah, gl_trans.hargasatuan, gl_trans.transaksi, gl_akun.akun, gl_akun.id as akun_id, gl_barang.id as brg_id, gl_barang.barang, gl_satuan.satuan FROM gl_trans, gl_akun, gl_barang, gl_satuan WHERE gl_akun.id = gl_trans.akun AND gl_barang.id = gl_trans.barang AND gl_satuan.id = gl_trans.satuan AND gl_trans.no_ref='$_GET[noreferensi]' AND gl_trans.pos='K' ORDER BY gl_trans.id desc";
$tr = mysql_query($query_tr, $con_gl) or die(mysql_error());
$row_tr = mysql_fetch_assoc($tr);
$totalRows_tr = mysql_num_rows($tr);

mysql_select_db($database_con_gl, $con_gl);
$query_get_idp = "SELECT gl_trans.id, gl_trans.akun FROM gl_trans WHERE gl_trans.no_ref='$_GET[noreferensi]' AND gl_trans.pos='D'";
$get_idp = mysql_query($query_get_idp, $con_gl) or die(mysql_error());
$row_get_idp = mysql_fetch_assoc($get_idp);
$totalRows_get_idp = mysql_num_rows($get_idp);

$totdeb = 0;
$totkre = 0;
?>
<link href="js/ui.datepicker.css" type="text/css" rel="stylesheet" />
<script type="text/javascript" src="js/ajax_data.js"></script>
<script type="text/javascript" src="js/ui.datepicker.js"></script>
<script type="text/javascript">
<!--
$(function()
      {
        $('.calendar').datepicker({
            appendText : "yyyy/mm/dd",
            dateFormat : 'yy/mm/dd'
          });
      });
</script>
<script type="text/javascript">
$(document).ready(function() {

	$().ajaxStart(function() {
		$('#loading').show();
		$('#result').hide();
	}).ajaxStop(function() {
		$('#loading').hide();
		$('#result').fadeIn('slow');
	});

	$('#delete').submit(function() {
		$.ajax({
			type: 'POST',
			url: $(this).attr('action'),
			data: $(this).serialize(),
			success: function(data) {
				$('#result').html(data);
			}
		})
		return false;
	});
  $('#result').click(function(){
  $(this).hide();
  });
})
</script>
<div id="loading" style="display:none;"><img src="images/loading.gif" alt="loading..." /></div>
<div id="result" style="display:none;"></div>
<h1>Hapus Persediaan</h1>
<form action="proses/persediaan.php?act=delete" method="POST" name="delete" id="delete" >
  <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" class="datatable">
    <tr valign="top">
      <td width="12%" align="right">Akun Piutang *: </td>
      <td width="29%">        <label>
          <select name="akun" id="akun" onfocus="this.blur();">
            <?php
do {  
?>
            <?php
mysql_select_db($database_con_gl, $con_gl);
$query_akun = "SELECT id, akun, klasifikasi, keterangan FROM gl_akun where klasifikasi = '$row_klas[kd]'";
if(!strstr($_SESSION[akses],'A-1-4')) {
	$query_akun .= " AND gudang='$_SESSION[lokasi]'";	
}
$query_akun .= " ORDER BY id,akun ASC";
$akun = mysql_query($query_akun, $con_gl) or die(mysql_error());
$row_akun = mysql_fetch_assoc($akun);
$totalRows_akun = mysql_num_rows($akun);
?>
            <option value="" style="background:#EEEEEE; font-weight:bold;"><?php echo $row_klas['klasifikasi'];?></option>
            <?php do { ?>
            <option value="<?php echo $row_akun['id']?>" <?php if($row_get_idp['akun']==$row_akun['id']) { ?>selected="selected"<?php } ?>>-<?php echo $row_akun['akun']?></option>
            <?php } while ($row_akun = mysql_fetch_assoc($akun));?>
            <?php
} while ($row_klas = mysql_fetch_assoc($klas));
  $rows = mysql_num_rows($klas);
  if($rows > 0) {
      mysql_data_seek($klas, 0);
	  $row_klas = mysql_fetch_assoc($klas);
  }
?>
        </select>
        </label>      </td>
      <td width="12%" align="right">Lokasi Kantor *:</td>
      <td width="51%"><label>
        <select name="gudang" id="gudang" onfocus="this.blur();">
          <?php
do {  
?><option value="<?php echo $row_gudang['id']?>"<?php if (!(strcmp($row_gudang['id'], $row_edit['gudang']))) {echo "selected=\"selected\"";} ?>><?php echo $row_gudang['gudang']?></option>
          <?php
} while ($row_gudang = mysql_fetch_assoc($gudang));
  $rows = mysql_num_rows($gudang);
  if($rows > 0) {
      mysql_data_seek($gudang, 0);
	  $row_gudang = mysql_fetch_assoc($gudang);
  }
?>
        </select>
      </label></td>
    </tr>
    <tr>
      <td align="right" valign="top">No. Referensi *:<br />
          <br />
        Tanggal *:</td>
      <td valign="top"><div id="refDiv">
        <label>
        <input name="noreferensi" type="text" id="noreferensi" value="<?php echo $row_edit['no_ref']; ?>" size="20" maxlength="20" onchange="cekReferensi(this.value);" onfocus="this.blur();"/>
        </label>
      </div>
        <br />
          <label>
          <input name="tanggal" type="text" class="calendar" id="tanggal" value="<?php echo $row_edit['tgl']; ?>" size="20" maxlength="15" onfocus="this.blur();"/>
        </label></td>
      <td align="right" valign="top">Keterangan :</td>
      <td valign="top"><label>
        <textarea name="keterangan" cols="58" rows="4" id="keterangan" onfocus="this.blur();"><?php echo $row_edit['keterangan']; ?></textarea>
        <input name="id_persediaan" type="hidden" id="id_persediaan" value="<?php echo $row_get_idp['id']; ?>" />
      </label></td>
    </tr>
    <tr>
      <td colspan="4" align="right"><div id="ajaxDiv">
        <table width="100%" border="0" cellspacing="0" cellpadding="5" class="datatable">
		<?php if($totalRows_tr > 0) { ?>
          <tr>
            <th align="center"><strong>Barang</strong></th>
            <th align="center"><strong>Satuan</strong></th>
            <th align="center"><strong>Jumlah</strong></th>
            <th align="center"><strong>Harga Satuan </strong></th>
            <th align="center"><strong>Total</strong></th>
            <th align="center"><strong>Transaksi</strong></th>
            <th align="center"><strong>Aksi</strong></th>
          </tr>
            <?php $tot_x = 0; do { ?>
              <tr valign="top">
                <td align="center" style="background:none;border:none;"><?php echo $row_tr['brg_id']; ?> - <?php echo $row_tr['barang']; ?></td>
                <td align="center" style="background:none;border:none;"><?php echo $row_tr['satuan']; ?></td>
                <td align="center" style="background:none;border:none;"><?php echo $row_tr['jumlah']; ?></td>
                <td align="right" style="background:none;border:none;"><?php echo number_format($row_tr['hargasatuan'],0,',','.').",-"; ?></td>
                <td align="right" style="background:none;border:none;"><?php echo number_format($row_tr['total'],0,',','.').",-"; $tot_x += $row_tr['total'];?></td>
                <td align="center" style="background:none;border:none;"><?php echo $row_tr['transaksi']; ?></td>
                <td width="10%" align="center" style="background:none;border:none;"><label>
                    <label>
                      <button value="Edit" onclick="ajaxEditFormPenyesuaian(<?php echo $row_tr['id']; ?>);" type="button" class="editbutton" title="Edit Transaksi" disabled="disabled">&nbsp;</button>
                  </label>
                    <label>
                    <input name="hapus" type="button" id="hapus" value="&nbsp;" onclick="ajaxManagePenyesuaian('Hapus',<?php echo $row_tr['id']; ?>);" title="Hapus Transaksi" class="deletebutton" disabled="disabled"/>
                  </label>
                </label></td>
              </tr>
              <?php } while ($row_tr = mysql_fetch_assoc($tr)); ?>
			  <tr valign="top" bgcolor="#FFFFFF">
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
                  <td align="right"><strong>Total :</strong> </td>
                  <td align="right"><?php echo number_format($tot_x,0,',','.').",-";?><input name="total_2" type="hidden" id="total_2" value="<?php echo $tot_x;?>" size="10" maxlength="15" /></td>
                  <td align="center">&nbsp;</td>
                  <td align="center">&nbsp;</td>
            </tr>
			  <?php } ?>
          <tr>
            <th width="28%" align="center"><strong>Barang</strong></th>
            <th width="10%" align="center"><strong>Satuan</strong></th>
            <th width="8%" align="center"><strong>Jumlah</strong></th>
            <th width="10%" align="center"><strong>Harga Satuan </strong></th>
            <th width="10%" align="center"><strong>Total</strong></th>
            <th align="center"><strong>Transaksi</strong></th>
            <th width="10%" align="center"><strong>Aksi</strong></th>
          </tr>
          <tr valign="top" bgcolor="#FFFFFF">
            <td align="center" style="background:none;border:none;"><label>
              <select name="barang" id="barang" style="width:400px;">
                <?php
do {  
mysql_select_db($database_con_gl, $con_gl);
$query_getpro = "SELECT id, barang, keterangan FROM gl_barang where kelompok='$row_kelom[id]' order by barang";
$getpro = mysql_query($query_getpro, $con_gl) or die(mysql_error());
$row_getpro = mysql_fetch_assoc($getpro);
$totalRows_getpro = mysql_num_rows($getpro);
?>
                <?php
 if($totalRows_getpro  > 0) { ?>
                <option value="" style="background:#DDDDDD;font-weight:bold;"><?php echo $row_kelom['kelompok']?></option>
                <?php do { ?>
                <option value="<?php echo $row_getpro['id']; ?>" title="<?php echo $row_getpro['keterangan']; ?>">-<?php echo $row_getpro['barang']; ?></option>
                <?php }  while ($row_getpro = mysql_fetch_assoc($getpro)); ?>
                <?php } ?>
                <?php
} while ($row_kelom = mysql_fetch_assoc($kelom));
  $rows = mysql_num_rows($kelom);
  if($rows > 0) {
      mysql_data_seek($kelom, 0);
	  $row_kelom = mysql_fetch_assoc($kelom);
  }
?>
              </select>
            </label></td>
            <td align="center" style="background:none;border:none;"><label>
              <select name="satuan" id="satuan">
                <?php
do {  
?>
                <option value="<?php echo $row_satuan['id']?>"><?php echo $row_satuan['satuan']?></option>
                <?php
} while ($row_satuan = mysql_fetch_assoc($satuan));
  $rows = mysql_num_rows($satuan);
  if($rows > 0) {
      mysql_data_seek($satuan, 0);
	  $row_satuan = mysql_fetch_assoc($satuan);
  }
?>
              </select>
            </label></td>
            <td align="center" style="background:none;border:none;"><label>
              <input name="jumlah" type="text" id="jumlah" onchange="javascript:this.form.total.value=this.form.jumlah.value * this.form.hargasatuan.value;" size="5" maxlength="5"/>
            </label></td>
            <td align="center" style="background:none;border:none;"><label>
              <input name="hargasatuan" type="text" id="hargasatuan" onchange="javascript:this.form.total.value=this.form.jumlah.value * this.form.hargasatuan.value;" size="10" maxlength="10"/>
            </label></td>
            <td align="center" style="background:none;border:none;"><label>
              <input name="total" type="text" id="total" onchange="javascript:if(this.value &gt; 0) { this.form.debet.value='';}else{ alert('Value invalid !!!');this.value='';}" size="10" maxlength="15"/>
            </label></td>
            <td width="10%" align="center" style="background:none;border:none;"><label>
              <textarea name="transaksi" cols="40" rows="3" id="transaksi"></textarea>
            </label></td>
            <td align="center" style="background:none;border:none;"><label></label>
                  <label>
                  <input name="add" type="button" id="add" value="&nbsp;" onclick="ajaxManagePenyesuaian('Tambah');" class="checkbutton" title="Tambah Transaksi" disabled="disabled"/>
                </label></td>
          </tr>
        </table>
      </div></td>
    </tr>
    <tr>
      <td align="right">&nbsp;</td>
      <td colspan="3" align="right"><input name="jenis" type="hidden" id="jenis" value="5" />
          <label>
          <input name="Save" type="submit" id="Save" value="Hapus Penyesuaian" />
        </label></td>
    </tr>
  </table>
</form>
